﻿// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
// 
// Copyright (c) 2012, Dr. Masroor Ehsan
// All rights reserved.
// 
// Redistribution and use in source and binary forms, with or without
// modification, are permitted provided that the following conditions are met:
//    * Redistributions of source code must retain the above copyright
//      notice, this list of conditions and the following disclaimer.
//    * Redistributions in binary form must reproduce the above copyright
//      notice, this list of conditions and the following disclaimer in the
//      documentation and/or other materials provided with the distribution.
//    * Neither the name of the <organization> nor the
//      names of its contributors may be used to endorse or promote products
//      derived from this software without specific prior written permission.
// 
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
// ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
// WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
// DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY
// DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
// (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
// LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
// ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
// (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
// SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
// 
// $Id: Db4oCatalog.cs 12 2012-01-27 06:11:46Z masroore@gmail.com $
// 
// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

using System;
using System.Collections.Generic;
using System.ComponentModel.Composition;
using System.IO;
using Db4objects.Db4o;
using DbCatalogCommon;
using LWObjects;

namespace Db4oCatalog
{
    [Export(typeof (IDbCatalog))]
    public class Db4oCatalog : IDbCatalog
    {
        #region IDbCatalog Members

        public void LoadCatalog(string fname)
        {
            using (var db = Db4oEmbedded.OpenFile(fname))
            {
                OrderableTestCatalog.Instance.Reset();
                ResultCodeCatalog.Instance.Reset();
                BillableItemsCatalog.Instance.Clear();
                TestPrefixGroupMap.Instance.Clear();

                var items = db.Query<KeyValuePair<string, string>>(typeof (KeyValuePair<string, string>));
                foreach (var kvp in items)
                {
                    TestPrefixGroupMap.Instance.Add(kvp.Key, kvp.Value);
                }

                foreach (var billableItem in db.Query<BillableItem>(typeof (BillableItem)))
                {
                    BillableItemsCatalog.Instance.Add(billableItem.Code, billableItem);
                }

                foreach (var resultCode in db.Query<ResultCode>(typeof (ResultCode)))
                {
                    ResultCodeCatalog.Instance.Add(resultCode.Code, resultCode);
                }

                foreach (var orderableTest in db.Query<OrderableTest>(typeof (OrderableTest)))
                {
                    db.Activate(orderableTest, 2);
                    OrderableTestCatalog.Instance.Add(orderableTest.TestId, orderableTest);
                }
            }
        }

        public void SaveCatalog(string fname)
        {
            if (File.Exists(fname))
            {
                File.Delete(fname);
            }

            using (var db = Db4oEmbedded.OpenFile(fname))
            {
                try
                {
                    foreach (var kvp in TestPrefixGroupMap.Instance)
                    {
                        db.Store(kvp);
                    }

                    foreach (var item in BillableItemsCatalog.Instance.Values)
                    {
                        db.Store(item);
                    }

                    foreach (var code in ResultCodeCatalog.Instance.Values)
                    {
                        db.Store(code);
                    }

                    foreach (var test in OrderableTestCatalog.Instance.Values)
                    {
                        db.Store(test);
                    }

                    db.Commit();
                }
                catch (Exception)
                {
                    db.Rollback();
                    throw;
                }
            }
        }

        #endregion
    }
}